USE [master]
GO

/****** Object:  Database [DCSDownloadHistoryDB]    Script Date: 01/17/2011 16:58:58 ******/
CREATE DATABASE [DCSDownloadHistoryDB] ON  PRIMARY 
( NAME = N'DCSDownloadHistoryDB', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\DCSDownloadHistoryDB.mdf' , SIZE = 27648KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage01] 
( NAME = N'PRLMessageFile01', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile01.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage02] 
( NAME = N'PRLMessageFile02', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile02.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage03] 
( NAME = N'PRLMessageFile03', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile03.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage04] 
( NAME = N'PRLMessageFile04', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile04.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage05] 
( NAME = N'PRLMessageFile05', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile05.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage06] 
( NAME = N'PRLMessageFile06', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile06.NDF' , SIZE = 20480KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage07] 
( NAME = N'PRLMessageFile07', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile07.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage08] 
( NAME = N'PRLMessageFile08', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile08.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage09] 
( NAME = N'PRLMessageFile09', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile09.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage10] 
( NAME = N'PRLMessageFile10', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile10.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage11] 
( NAME = N'PRLMessageFile11', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile11.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
 FILEGROUP [PRLMessage12] 
( NAME = N'PRLMessageFile12', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\PRLMessageFile12.NDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'DCSDownloadHistoryDB_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\DCSDownloadHistoryDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DCSDownloadHistoryDB].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ARITHABORT OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET AUTO_CREATE_STATISTICS ON 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET  DISABLE_BROKER 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET  READ_WRITE 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET RECOVERY FULL 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET  MULTI_USER 
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [DCSDownloadHistoryDB] SET DB_CHAINING OFF 
GO


